drop table acc_antiback;
drop table acc_door;
drop table acc_firstopen;
drop table acc_firstopen_emp;
drop table acc_holidays;
drop table acc_interlock;
drop table acc_levelset;
drop table acc_levelset_door_group;
drop table acc_levelset_emp
drop table acc_linkageio;
drop table acc_map;
drop table acc_mapdoorpos;
drop table acc_monitor_log;
drop table acc_morecardempgroup;
drop table acc_morecardgroup;
drop table acc_morecardset;
drop table acc_timeseg
drop table acc_wiegandfmt;
drop table ACGroup;
drop table acholiday;
drop table ACTimeZones;
drop table action_log;
drop table ACUnlockComb;
drop table AlarmLog;
drop table areaadmin;
drop table att_attreport;
drop table att_waitforprocessdata;
drop table attcalclog;
drop table attexception;
drop table AttParam;
drop table AuditedExc;
drop table auth_group;
drop table auth_group_permissions;
drop table auth_message;
drop table auth_permission;
drop table auth_user;
drop table auth_user_groups;
drop table auth_user_user_permissions;
drop table AUTHDEVICE;
drop table base_additiondata;
drop table base_appoption;
drop table base_basecode;
drop table base_datatranslation;
drop table base_operatortemplate;
drop table base_option;
drop table base_personaloption;
drop table base_strresource;
drop table base_strtranslation;
drop table base_systemoption;
drop table CHECKEXACT;
drop table CHECKINOUT;
drop table dbapp_viewmodel;
drop table dbbackuplog;
drop table DEPARTMENTS;
drop table deptadmin;
drop table DeptUsedSchs;
drop table devcmds;
drop table devcmds_bak;
drop table devlog;
drop table django_content_type;
drop table django_session;
drop table EmOpLog;
drop table empitemdefine;
drop table EXCNOTES;
drop table FaceTemp;
drop table HOLIDAYS;
drop table iclock_dstime;
drop table iclock_oplog;
drop table iclock_testdata;
drop table iclock_testdata_admin_area;
drop table iclock_testdata_admin_dept;
drop table LeaveClass;
drop table LeaveClass1;
drop table Machines;
drop table NUM_RUN;
drop table NUM_RUN_DEIL;
drop table operatecmds;
drop table personnel_area;
drop table personnel_cardtype;
drop table personnel_empchange;
drop table personnel_issuecard;
drop table personnel_leavelog;
drop table ReportItem;
drop table SchClass;
drop table SECURITYDETAILS;
drop table ServerLog;
drop table SHIFT;
drop table SystemLog;
drop table TBKEY;
drop table TBSMSALLOT;
drop table TBSMSINFO;
drop table TEMPLATE;
drop table USER_OF_RUN;
drop table USER_SPEDAY;
drop table USER_TEMP_SCH;
drop table UserACMachines;
drop table UserACPrivilege;
drop table USERINFO;
drop table userinfo_attarea;
drop table UsersMachines;
drop table UserUpdates;
drop table UserUsedSClasses;
drop table worktable_groupmsg;
drop table worktable_instantmsg;
drop table worktable_msgtype;
drop table worktable_usrmsg;
drop table ZKAttendanceMonthStatistics;
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[acc_reader]') AND type in (N'U')) DROP TABLE [acc_reader]
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[acc_auxiliary]') AND type in (N'U')) DROP TABLE [acc_auxiliary]